﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_STATES_IN')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_STATES_IN
	END

GO

CREATE Procedure dbo.PRC_TB_STATES_IN
	(
		@TS_DESCRIPTION varchar(150)
	)

AS

insert into tb_states
(TS_DESCRIPTION)
values
(@TS_DESCRIPTION)

GO

GRANT EXEC ON dbo.PRC_TB_STATES_IN TO PUBLIC

GO

